3a877bb58e835c0491a70cd534309d0c57e7747e,tests/frontend/org/voltdb/regressionsuites/TestPlansGroupBySuite.java,TestPlansGroupBySuite,testDistributedSum,#,342
Before Change
vt = client.callProcedure("@AdHoc", qs).getResults()[0];
System.out.println("testDistributedSum result: " + vt);
assertTrue(vt.getRowCount() == 1);
while (vt.advanceRow()) {
Integer sum1 = (Integer) vt.get(0, VoltType.INTEGER);
assertEquals(2000, sum1.intValue());
Integer sum2 = (Integer) vt.get(1, VoltType.INTEGER);
assertEquals(4995000, sum2.intValue());
Integer sum3 = (Integer) vt.get(2, VoltType.INTEGER);
assertEquals(500, sum3.intValue());
}
}
After Change
vt = client.callProcedure("@AdHoc", qs).getResults()[0];
System.out.println("testDistributedSum result: " + vt);
assertTrue(vt.getRowCount() == 1);
vt.advanceRow();
Integer sum1 = (Integer) vt.get(0, VoltType.INTEGER);
assertEquals(2000, sum1.intValue());
Integer sum2 = (Integer) vt.get(1, VoltType.INTEGER);
assertEquals(4995000, sum2.intValue());
Integer sum3 = (Integer) vt.get(2, VoltType.INTEGER);
assertEquals(500, sum3.intValue());
// Also, regression test ENG-199 -- duplicate aggregation column.
vt = client.callProcedure("@AdHoc", "select sum(F_VAL1), sum(F_VAL1) from F").getResults()[0];